package org.example.etl.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import org.example.etl.entity.Callsaturation;

public interface CallSaturationMapper extends BaseMapper<Callsaturation> {

    @Select(" SELECT COUNT(*) from callsaturation_number where THBH_SECT=#{setc};")
    public boolean isExistThiscallSaturation(String setc);

    @Update("update callsaturation_number set SEND_TIME=#{callSaturation.getSendTime()},AREA_SOURCE=#{callSaturation.getAreaSource()},THBH_TIME=#{callSaturation.getThbhTime()},THBH_VALUE=#{callSaturation.getThbhValue()}  where THBH_SECT=#{callSaturation.getThbhSect()}; ")
    public void updateAncallSaturationMsg(Callsaturation callSaturation);

}
